Service Sales and Purchases Fields

Service Sales and Purchases Fields

Field

Sales or Purchases

Description and Character Limits

*Co./Last Name

Both

Must match a preexisting card in your MYOB AccountEdge data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB AccountEdge matches the last name followed by a comma and a space, followed by the first name.)

First Name

Both

20 characters, alphanumeric

Addr 1 - Line 1
- Line 2
- Line 3
- Line 4

Both

Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric

Sale Status

Sale

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.

Purchase Status

Purchase

1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.

Invoice #

Sales

8 characters, alphanumeric

Purchase Order#

Purchases

8 characters, alphanumeric

Date

Both

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Customer P/O #

Sales

20 characters, alphanumeric

Vendor Invoice #

Purchases

20 characters, alphanumeric

Ship Via

Both

20 characters, alphanumeric. If the ship via method does not exist in the shipping methods list, it will be ignored

Already Printed

Both

1 character. Any non-blank character signifies that the invoice or purchase order is already printed or sent

Description

Both

255 characters, alphanumeric

*Account #

Both

Must be valid, preexisting MYOB AccountEdge account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).

*Amount

Both

15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB AccountEdge rounds to the nearest cent.

Job

Both

5 characters, alphanumeric. Must match preexisting job number in your MYOB software data file.

Comment

Both

255 characters, alphanumeric

Journal Memo

Both

255 characters, alphanumeric

Slsmn Last Name

Sales

31 characters, alphanumeric. Must match the name of an employee card in the MYOB software data file.

Slsmn First Name

Sales

15 characters, alphanumeric.

Shipping Date

Both

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Referral Source

Sales

20 characters, alphanumeric.

Tax Code

Both

3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.

Tax Amount

Both

15 characters, numeric, including 2 decimal places

Freight Amount

Both

15 characters, numeric, including 2 decimal places

Freight Tax

Both

Any non-blank character indicates freight is taxed.

Freight Tax Code

Both

3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.

Sale Status

Sales

1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.

Purchase Status

Purchases

1 character. O indicates the purchase is an order, Q indicates the purchase is a quote. Any other character or no character indicates the purchase is a bill.

Currency Code

Both

3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.

Exchange Rate

Both

11 digits, including 6 decimal places. If blank, current exchange rate substituted.

Terms ñ

Payment is Due

Both

1 character, numeric. Use one of these codes to indicate when payment is due:

0 - COD
1 - Prepaid
2 - In a Given # of Days
3 - On a Day of the Month
4 - # of days after EOM
5 - Day of Month after EOM

- Discount Days

Both

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- Balance Due Days

Both

3 characters, numeric
If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999.
If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)

- % Discount

Both

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

- % Monthly Charge

Sales

2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.

Amount Paid

Both

15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.

Payment Date

Both

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.

Payment Method

Sales

20 characters, alphanumeric.

Payment Notes

Sales

255 characters, alphanumeric.

Name on Card

Sales

50 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Card Number

Sales

25 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Expiration Date

Sales

10 characters, alphanumeric. Only available for credit card and debit card methods of payment.

Authorization

Sales

255 characters, alphanumeric. Only available for credit card and debit card methods of payment.

*This is a required field for importing.

Field	Sales or Purchases	Description and Character Limits
*Co./Last Name	Both	Must match a preexisting card in your MYOB AccountEdge data file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, MYOB AccountEdge matches the last name followed by a comma and a space, followed by the first name.)
First Name	Both	20 characters, alphanumeric
Addr 1 - Line 1 - Line 2 - Line 3 - Line 4	Both	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric
Sale Status	Sale	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the sale is an invoice.
Purchase Status	Purchase	1 alphanumeric character. O indicates an order. Q indicates a quote. Any other character or blank indicates the purchase is a bill.
Invoice #	Sales	8 characters, alphanumeric
Purchase Order#	Purchases	8 characters, alphanumeric
Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Customer P/O #	Sales	20 characters, alphanumeric
Vendor Invoice #	Purchases	20 characters, alphanumeric
Ship Via	Both	20 characters, alphanumeric. If the ship via method does not exist in the shipping methods list, it will be ignored
Already Printed	Both	1 character. Any non-blank character signifies that the invoice or purchase order is already printed or sent
Description	Both	255 characters, alphanumeric
*Account #	Both	Must be valid, preexisting MYOB AccountEdge account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234).
*Amount	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB AccountEdge rounds to the nearest cent.
Job	Both	5 characters, alphanumeric. Must match preexisting job number in your MYOB software data file.
Comment	Both	255 characters, alphanumeric
Journal Memo	Both	255 characters, alphanumeric
Slsmn Last Name	Sales	31 characters, alphanumeric. Must match the name of an employee card in the MYOB software data file.
Slsmn First Name	Sales	15 characters, alphanumeric.
Shipping Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Referral Source	Sales	20 characters, alphanumeric.
Tax Code	Both	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Tax Amount	Both	15 characters, numeric, including 2 decimal places
Freight Amount	Both	15 characters, numeric, including 2 decimal places
Freight Tax	Both	Any non-blank character indicates freight is taxed.
Freight Tax Code	Both	3 characters, alphanumeric. Must match a preexisting tax code in the Tax Code List.
Sale Status	Sales	1 character. O indicates the sale is an order, Q indicates the sale is a quote. Any other character or no character indicates the sale is an invoice.
Purchase Status	Purchases	1 character. O indicates the purchase is an order, Q indicates the purchase is a quote. Any other character or no character indicates the purchase is a bill.
Currency Code	Both	3 characters, alpha. One code per sale/purchase. Must match a preexisting currency code in the Currency List. Must match customer/vendor currency code.
Exchange Rate	Both	11 digits, including 6 decimal places. If blank, current exchange rate substituted.
Terms ñ Payment is Due	Both	1 character, numeric. Use one of these codes to indicate when payment is due: 0 - COD 1 - Prepaid 2 - In a Given # of Days 3 - On a Day of the Month 4 - # of days after EOM 5 - Day of Month after EOM
- Discount Days	Both	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
- Balance Due Days	Both	3 characters, numeric If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you chose code 3 or 5 to indicate when payment is due, use a date from 1-31. (EOM=31)
- % Discount	Both	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
- % Monthly Charge	Sales	2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point.
Amount Paid	Both	15 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent.
Payment Date	Both	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years.
Payment Method	Sales	20 characters, alphanumeric.
Payment Notes	Sales	255 characters, alphanumeric.
Name on Card	Sales	50 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Card Number	Sales	25 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Expiration Date	Sales	10 characters, alphanumeric. Only available for credit card and debit card methods of payment.
Authorization	Sales	255 characters, alphanumeric. Only available for credit card and debit card methods of payment.